#!/bin/bash

# where your copt of the parser is
INSTALLDIR=""
DATABASE="your database's name"
PASSWORD="your database password"

pushd $INSTALLDIR
echo "Dropping tables."
mysql -p $DATABASE --password='$PASSWORD' < ../sql/drop_univis_tables.sql
echo "Creating tables."
mysql -p $DATABASE --password='$PASSWORD' < ../sql/create_db_schema.sql
echo "Running UnivIS update."
php univis2mysql.php
popd
